package com.atguigu.gulimall.product.service.impl;

import com.atguigu.gulimall.product.entity.AttrEntity;
import com.atguigu.gulimall.product.service.AttrService;
import com.atguigu.gulimall.product.vo.AttrGroupWithAttrsVo;
import com.atguigu.gulimall.product.vo.SpuItemAttrGroupVo;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.atguigu.common.utils.PageUtils;
import com.atguigu.common.utils.Query;

import com.atguigu.gulimall.product.dao.AttrGroupDao;
import com.atguigu.gulimall.product.entity.AttrGroupEntity;
import com.atguigu.gulimall.product.service.AttrGroupService;
import org.springframework.util.StringUtils;


@Service("attrGroupService")
public class AttrGroupServiceImpl extends ServiceImpl<AttrGroupDao, AttrGroupEntity> implements AttrGroupService {

    @Autowired
    AttrService attrService;

    //逆向生成的查询所有
    @Override
    public PageUtils queryPage(Map<String, Object> params) {
        IPage<AttrGroupEntity> page = this.page(
                new Query<AttrGroupEntity>().getPage(params),//分页条件
                new QueryWrapper<AttrGroupEntity>()//查询条件没有
        );

        return new PageUtils(page);
    }

//    @Override
//    public PageUtils queryPage(Map<String, Object> params, Long catelogId) {
////        String key = (String) params.get("key");
//        //select * from pms_attr_group where catelog_id=? and (attr_group_id=key or attr_group_name like %key%)
////        QueryWrapper<AttrGroupEntity> wrapper = new QueryWrapper<AttrGroupEntity>();
////        if(!StringUtils.isEmpty(key)){
////            wrapper.and((obj)->{
////                obj.eq("attr_group_id",key).or().like("attr_group_name",key);
////            });
////        }
//
//        if (catelogId == 0) {//如果传来0:查询所有数据
//            IPage<AttrGroupEntity> page = this.page(
//                    new Query<AttrGroupEntity>().getPage(params),
//                    new QueryWrapper<AttrGroupEntity>()
//            );
//            return new PageUtils(page);
//        }else {
//            String key = (String) params.get("key");
//            QueryWrapper<AttrGroupEntity> wrapper = new QueryWrapper<AttrGroupEntity>().eq("catelogId",catelogId);
//            if(!StringUtils.isEmpty(key)){
//                wrapper.and((obj)->{
//                    obj.eq("attr_group_id",key).or().like("attr_group_name",key);
//                });
//            }
////            wrapper.eq("catelog_id",catelogId);
//            IPage<AttrGroupEntity> page = this.page(new Query<AttrGroupEntity>().getPage(params),
//                    wrapper);
//            return new PageUtils(page);
//        }
//    }

    @Override
    public PageUtils queryPage(Map<String, Object> params, Long catelogId) {
        String key = (String) params.get("key");
        //select * from pms_attr_group where catelog_id=? and (attr_group_id=key or attr_group_name like %key%)
        //构造sql语句的查询条件QueryWrapper，泛型传实体类对应的表
        QueryWrapper<AttrGroupEntity> wrapper = new QueryWrapper<AttrGroupEntity>();
        //如果key不为空，按key(关键字)进行模糊查询
        if(!StringUtils.isEmpty(key)){
            wrapper.and((obj)->{
                //sql语句关键词=id，或者=name
                obj.eq("attr_group_id",key).or().like("attr_group_name",key);
            });
        }
//如果传来0:查询所有数据
        if( catelogId == 0){
            IPage<AttrGroupEntity> page = this.page(new Query<AttrGroupEntity>().getPage(params),
                    wrapper);
            return new PageUtils(page);
        }else {
            //否则点击哪个查哪个，sql语句：catelog_id=传来的id
            wrapper.eq("catelog_id",catelogId);
            IPage<AttrGroupEntity> page = this.page(
                    new Query<AttrGroupEntity>().getPage(params),//传入分页
                    wrapper);//查询条件语句
            return new PageUtils(page);
        }
    }

    /**
     * 发布商品：根据分类id查出所有的分组以及这些组里面的属性
     * @param catelogId
     * @return
     */
    @Override
    public List<AttrGroupWithAttrsVo> getAttrGroupWithAttrsByCatelogId(Long catelogId) {
        //com.atguigu.gulimall.product.vo
        //1、查询分组信息
        List<AttrGroupEntity> attrGroupEntities = this.list(new QueryWrapper<AttrGroupEntity>().eq("catelog_id", catelogId));

        //2、查询所有属性
        List<AttrGroupWithAttrsVo> collect = attrGroupEntities.stream().map(group -> {
            AttrGroupWithAttrsVo attrsVo = new AttrGroupWithAttrsVo();
            //先把分组信息放入vo
            BeanUtils.copyProperties(group,attrsVo);
            //再把每个分组的属性放入vo
            List<AttrEntity> attrs = attrService.getRelationAttr(attrsVo.getAttrGroupId());//之前自定义的方法
            attrsVo.setAttrs(attrs);
            return attrsVo;
        }).collect(Collectors.toList());

        return collect;


    }

    @Override
    public List<SpuItemAttrGroupVo> getAttrGroupWithAttrsBySpuId(Long spuId, Long catalogId) {
        //1、查出当前spu对应的所有属性的分组信息以及当前分组下的所有属性对应的值
        AttrGroupDao baseMapper = this.getBaseMapper();
        List<SpuItemAttrGroupVo> vos = baseMapper.getAttrGroupWithAttrsBySpuId(spuId,catalogId);

        //SELECT pav.`spu_id`,ag.`attr_group_name`,ag.`attr_group_id`,aar.`attr_id`,attr.`attr_name`,pav.`attr_value`
        // FROM `pms_attr_group` ag
        // LEFT JOIN `pms_attr_attrgroup_relation` aar
        // ON aar.`attr_group_id` = ag.`attr_group_id`
        // LEFT JOIN `pms_attr` attr ON attr.`attr_id` = aar.`attr_id`
        // LEFT JOIN `pms_product_attr_value` pav ON pav.`attr_id` = attr.`attr_id`
        // WHERE ag.catelog_id = 225 AND pav.`spu_id` = 13
        return vos;
    }
}